The purpose of this investigation is to graph each customer’s overall satisfaction based on their business purpose. This is then further broken down by the membership level of each customer.
These graphs can be applied to a real world scenario in which a hotel wishes to gain an insight into the level of satisfaction across its customer base. The hotel would put stress on wanting to know the satisfaction of their most profitable customers (i.e. Platinum membership customers) with a secondary stress on finding the general satisfaction landscape for all customers.
The following graphs are created from a data set containing a large amount of satisfaction ratings by customers staying at a hotel. The following fields are in the set:
| Field | Description |
|---|---|
| custID | The Customer’s ID, used as the primary key (format: ID_* where * is the next sequential number) |
| satCleanRoom | Customer’s satisfaction with their room’s cleanliness (0-7) |
| satCleanBath | Customer’s satisfaction with their bath’s cleanliness (0-7) |
| satCleanCommon | Customer’s satisfaction with the common room’s cleanliness (0-7) |
| satRoomPrice | Customer’s satisfaction with their room price (0-7) |
| satDiningPrice | Customer’s satisfaction with food prices (0-7) |
| satWifiPrice | Customer’s satisfaction with Wi-Fi price (0-7) |
| satParkingPrice | Customer’s satisfaction with parking price (0-7) |
| satPerks | Customer’s satisfaction with membership perks (0-7) |
| satCity | Customer’s satisfaction with the city (0-7) |
| satCloseTransp | Customer’s satisfaction with nearby transport (0-7) |
| satCloseEvents | Customer’s satisfaction with nearby events (0-7) |
| satPoints | Customer’s satisfaction with nearby points of interest (0-7) |
| satRecognition | Customer’s satisfaction with hotel recognition (0-7) |
| satFrontStaff | Customer’s satisfaction with the hotel’s front staff (0-7) |
| satDiningStaff | Customer’s satisfaction with hotel’s dining staff (0-7) |
| satHouseStaff | Customer’s satisfaction with hotel’s house staff (0-7) |
| satValetStaff | Customer’s satisfaction with hotel’s valet staff (0-7) |
| satOverall | Customer’s overall satisfaction (0-7) |
| distanceTraveled | Distance traveled by customer to the hotel (miles rounded to nearest whole no.) |
| nightsStayed | Nights stayed by customer (number) |
| visitPurpose | Purpose of customer’s visit (Business/Concert/Conference/OtherOrMixed/SportsEvent/Vacation) |
| avgRoomSpendPerNight | Average amount spent on the customer’s room per night (Dollars) |
| avgFoodSpendPerNight | Average amount spent on the customer’s food per night (Dollars) |
| avgWifiSpendPerNight | Average amount spent on the customer’s Wi-Fi per night (Dollars) |
| eliteSegment | Customer’s membership level (NoStatus/Silver/Gold/Platinum) |